home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
PCGUIA 117
/
PC Guia 117.iso
/
Software
/
Produtividade
/
Software2
/
Product4
/
Setup.exe
/
drupal-4.6.0
/
scripts
/
prefix.sh
< prev
Encoding:
Amiga
Atari
Commodore
DOS
FM Towns/JPY
Macintosh
Macintosh JP
Macintosh to JP
NeXTSTEP
RISC OS/Acorn
Shift JIS
UTF-8
Wrap
Linux/UNIX/POSIX Shell Script
|
2004-11-24
|
366 b
|
22 lines
#!/bin/sh
if [ $# != 2 ]; then
cat >&2 << EOH
This is Drupal database prefixer.
Usage:
$0 prefix original_db.sql >prefixed_db.sql
- all tables will prefixed with 'prefix'
EOH
exit 1;
fi
PRFX=$1;
sed "s/^CREATE TABLE /CREATE TABLE $PRFX/;
s/^INSERT INTO /INSERT INTO $PRFX/;
s/^REPLACE /REPLACE $PRFX/;
s/^ALTER TABLE /ALTER TABLE $PRFX/" $2